CREATE TABLE [dbo].[CertificationModuleGrade]
(
[CertificationModuleGradeKey] [uniqueidentifier] NOT NULL,
[CertificationModuleKey] [uniqueidentifier] NOT NULL,
[GradeKey] [uniqueidentifier] NOT NULL,
[PassFlag] [bit] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[CertificationModuleGrade] ADD CONSTRAINT [PK_CertificationModuleGradeKey] PRIMARY KEY CLUSTERED ([CertificationModuleGradeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleGrade_CertificationModuleKey] ON [dbo].[CertificationModuleGrade] ([CertificationModuleKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleGrade_CreatedByUserKey] ON [dbo].[CertificationModuleGrade] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleGrade_GradeKey] ON [dbo].[CertificationModuleGrade] ([GradeKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_CertificationModuleGrade_UpdatedByUserKey] ON [dbo].[CertificationModuleGrade] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CertificationModuleGrade] ADD CONSTRAINT [FK_CertificationModuleGrade_CertificationModule] FOREIGN KEY ([CertificationModuleKey]) REFERENCES [dbo].[CertificationModule] ([CertificationModuleKey])
GO
ALTER TABLE [dbo].[CertificationModuleGrade] ADD CONSTRAINT [FK_CertificationModuleGrade_GradeRef] FOREIGN KEY ([GradeKey]) REFERENCES [dbo].[GradeRef] ([GradeKey])
GO
ALTER TABLE [dbo].[CertificationModuleGrade] ADD CONSTRAINT [FK_CertificationModuleGrade_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[CertificationModuleGrade] ADD CONSTRAINT [FK_CertificationModuleGrade_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO